<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/zhazhagu/article/details/81064406"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"MySQL允许root远程登录 - 小谷的博客"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>MySQL允许root远程登录 - 小谷的博客 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
            <script type="application/ld+json">{"@context":"https:\/\/ziyuan.baidu.com\/contexts\/cambrian.jsonld","@id":"https:\/\/blog.csdn.net\/zhazhagu\/article\/details\/81064406","appid":"1563894916825412","title":"MySQL\u5141\u8bb8root\u8fdc\u7a0b\u767b\u5f55 - \u5c0f\u8c37\u7684\u535a\u5ba2","images":["https:\/\/img-blog.csdn.net\/20180716142151124?watermark\/2\/text\/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYXpoYWd1\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70","https:\/\/img-blog.csdn.net\/20180716141950111?watermark\/2\/text\/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYXpoYWd1\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70","https:\/\/img-blog.csdn.net\/20180716142320316?watermark\/2\/text\/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYXpoYWd1\/font\/5a6L5L2T\/fontsize\/400\/fill\/I0JBQkFCMA==\/dissolve\/70"],"pubDate":"2019-08-09T15:09:57"}</script>
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin-blue/skin-blue-b7967eb1c8.min.css">
        <script type="text/javascript">
        var username = "zhazhagu";
        var blog_address = "https://blog.csdn.net/zhazhagu";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/zhazhagu/article/details/81064406"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin-blue";
        // 收藏所需数据
        var articleTitle = "MySQL允许root远程登录";
        var articleDesc = "新安装的数据库只能localhost访问？？是不是很苦逼下面介绍如何允许远程访问root1.“试一下”能否远程登录&amp;gt;mysql-uroot-p-h10.0.42.180  答案是否定的。那就开始进行设置吧2.登录数据库,默认本地访问&amp;gt;mysql-uroot-p3.切换mysql数据库mysql&amp;gt;usem...";
        // 第四范式所需数据
        var articleTitles = "MySQL允许root远程登录 - 小谷的博客";
        
        var nickName = "小gu";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/zhazhagu/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/zhazhagu/article/details/81064406";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">MySQL允许root远程登录</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2018年07月16日 14:40:29</span>
                    <a class="follow-nickName" href="https://me.csdn.net/zhazhagu" target="_blank">小gu</a>
                    <span class="read-count">阅读数 13473</span>
                                    </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                <div class="htmledit_views" id="content_views">
                                            <p>新安装的数据库只能localhost访问？？是不是很苦逼</p>

<p>下面介绍如何允许远程访问root</p>

<p>1. “试一下”能否远程登录</p>

<pre class="has">
<code class="language-sql">&gt; mysql -u root -p -h 10.0.42.180</code></pre>

<p><img alt="" class="has" src="https://img-blog.csdn.net/20180716142151124?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYXpoYWd1/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" /></p>

<p>    答案是否定的。那就开始进行设置吧</p>

<p>2. 登录数据库,默认本地访问</p>

<pre class="has">
<code class="language-sql">&gt; mysql -u root -p</code></pre>

<p><img alt="" class="has" src="https://img-blog.csdn.net/20180716141950111?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYXpoYWd1/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" /></p>

<p>3.切换mysql数据库</p>

<pre class="has">
<code class="language-sql">mysql&gt; use mysql</code></pre>

<p><img alt="" class="has" src="https://img-blog.csdn.net/20180716142320316?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYXpoYWd1/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" /></p>

<p>4.执行查询，查看数据库当前有访问权限的信息</p>

<pre class="has">
<code class="language-sql">mysql&gt; SELECT User, Password, Host FROM user;</code></pre>

<p><img alt="" class="has" src="https://img-blog.csdn.net/20180716142452120?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYXpoYWd1/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" /></p>

<p>只有localhost才能访问</p>

<p>5.设置访问权限</p>

<pre class="has">
<code class="language-sql">mysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;</code></pre>

<p><img alt="" class="has" src="https://img-blog.csdn.net/2018071614260254?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYXpoYWd1/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" /></p>

<p>其中"*.*"代表所有资源所有权限， “'root'@%”其中root代表账户名，%代表所有的访问地址，也可以使用一个唯一的地址进行替换，只有一个地址能够访问。如果是某个网段的可以使用地址与%结合的方式，如10.0.42.%。IDENTIFIED BY 'root'，这个root是指访问密码。WITH GRANT OPTION允许级联授权。</p>

<p>6.刷新访问权限表（不要忘了）</p>

<pre class="has">
<code class="language-sql">mysql&gt; FLUSH PRIVILEGES;</code></pre>

<p><img alt="" class="has" src="https://img-blog.csdn.net/20180716143424986?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYXpoYWd1/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" /></p>

<p>7. 重新查看用户表</p>

<p> </p>

<pre class="has">
<code class="language-sql">mysql&gt; SELECT User, Password, Host FROM user;</code></pre>

<p><img alt="" class="has" src="https://img-blog.csdn.net/20180716143455505?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYXpoYWd1/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" /></p>

<p>8.验证远程访问</p>

<p> </p>

<pre class="has">
<code class="language-sql">&gt; mysql -u root -p -h 10.0.42.180</code></pre>

<p><img alt="" class="has" src="https://img-blog.csdn.net/20180716143548513?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYXpoYWd1/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70" /></p>

<p>OK，登录成功</p>                                    </div>
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/zhazhagu/article/details/81064406","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/zhazhagu/article/details/81064406","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-386","con":",,"}' data-track-click='{"mod":"kp_popu_58-386","con":",,"}' data-report-view='{"mod":"kp_popu_58-386","keyword":""}' data-report-click='{"mod":"kp_popu_58-386","keyword":""}'><div style="width:100%;background:#fff;">
<script type="text/javascript" src="//rabc1.iteye.com/production/resource/web/6xwm4l.js?lg=ydmpioh"></script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="81064406">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_35923749/article/details/79177261","strategy":"BlogCommendFromAutoMl2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_35923749/article/details/79177261" target="_blank" title="MySQL数据库远程访问权限如何打开(两种方法)">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>数据库远程访问权限如何打开(两种方法)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-26</span>
				<span class="read-num hover-hide">
					阅读数 
					9094</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_35923749/article/details/79177261" target="_blank" title="MySQL数据库远程访问权限如何打开(两种方法)">
				<span class="desc oneline">在我们使用mysql数据库时，有时我们的程序与数据库不在同一机器上，这时我们需要远程访问数据库。缺省状态下，mysql的用户没有远程访问的权限。下面介绍两种方法，解决这一问题。1、改表法可能是你的帐号...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_35923749">来自：	<span class="blog_title"> 凌凌小博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_34126805/article/details/81566191","strategy":"BlogCommendFromAutoMl2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_34126805/article/details/81566191" target="_blank" title="Mysql修改远程登录的两种方法">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>修改<em>远程登录</em>的两种方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-10</span>
				<span class="read-num hover-hide">
					阅读数 
					955</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_34126805/article/details/81566191" target="_blank" title="Mysql修改远程登录的两种方法">
				<span class="desc oneline">1.直接修改表中的数据mysql-uroot-pmysql&amp;amp;gt;usemysql;mysql&amp;amp;gt;updateusersethost='%'whereuser='root';mys...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_34126805">来自：	<span class="blog_title"> qq_34126805的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/jie11447416/article/details/53444656","strategy":"BlogCommendFromAutoMl2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jie11447416/article/details/53444656" target="_blank" title="mysql设置root密码，并且允许远程连接">
		<h4 class="text-truncate oneline">
				<em>mysql</em>设置<em>root</em>密码，并且<em>允许</em>远程连接		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-03</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jie11447416/article/details/53444656" target="_blank" title="mysql设置root密码，并且允许远程连接">
				<span class="desc oneline">修改mysql的root用户的密码；连接数据库的时候，遇到hostisnotallowedtoconnectmysql，这个说明mysql不允许连接，允许root远程连接。...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jie11447416">来自：	<span class="blog_title"> 星雨晴空</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/konglongaa/article/details/80996829","strategy":"BlogCommendFromAutoMl2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/konglongaa/article/details/80996829" target="_blank" title="mysql给root开启远程访问权限">
		<h4 class="text-truncate oneline">
				<em>mysql</em>给<em>root</em>开启远程访问权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-11</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/konglongaa/article/details/80996829" target="_blank" title="mysql给root开启远程访问权限">
				<span class="desc oneline">本人在阿里云买了个服务器，自带mysql，感觉不能每次都通过Xshell去操作远程服务器，想尝试通过本地的sqlyog管理工具去连接，但是即使账号密码全正确，也会报错：errorno.1045acce...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/konglongaa">来自：	<span class="blog_title"> kongjunlongaa的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-860","con":",,SQL"}' data-track-click='{"mod":"kp_popu_59-860","con":",,SQL"}' data-report-view='{"mod":"kp_popu_59-860","keyword":"SQL"}' data-report-click='{"mod":"kp_popu_59-860","keyword":"SQL"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/109?positionId=59&queryWord=SQL" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/rrrrroy_Ha/article/details/74925510","strategy":"BlogCommendFromAutoMl2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/rrrrroy_Ha/article/details/74925510" target="_blank" title="对MySQL开放远程连接权限的方法">
		<h4 class="text-truncate oneline">
				对<em>MySQL</em>开放远程连接权限的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-10</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/rrrrroy_Ha/article/details/74925510" target="_blank" title="对MySQL开放远程连接权限的方法">
				<span class="desc oneline">背景：2016年9月22日，中途要求做一个评价系统，由于之前被人做过一小部分，有现成的数据库（数据库：MySQL5.7，数据库软件：MySQLworkbench6.3CE），为了省去安装数据库导出导入...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/rrrrroy_Ha">来自：	<span class="blog_title"> rrrrroy_Ha的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/helloxiaozhe/article/details/76229074","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<div class="content">
		<a href="https://blog.csdn.net/helloxiaozhe/article/details/76229074" target="_blank" title="命令行登录Mysql，远程登录Mysql的方法">
		<h4 class="text-truncate oneline">
				命令行登录<em>Mysql</em>，<em>远程登录</em><em>Mysql</em>的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-28</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/helloxiaozhe/article/details/76229074" target="_blank" title="命令行登录Mysql，远程登录Mysql的方法">
				<span class="desc oneline">命令行登录Mysql，远程登录Mysql的方法</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/helloxiaozhe">来自：	<span class="blog_title"> helloxiaozhe的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zdb1314/article/details/78469016","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zdb1314/article/details/78469016" target="_blank" title="允许远程用户登录访问mysql的方法">
		<h4 class="text-truncate oneline">
				<em>允许</em>远程用户登录访问<em>mysql</em>的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-07</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zdb1314/article/details/78469016" target="_blank" title="允许远程用户登录访问mysql的方法">
				<span class="desc oneline">允许远程用户登录访问mysql的方法需要手动增加可以远程访问数据库的用户。方法一(不推荐)、本地登入mysql，更改&quot;mysql&quot;数据库里的&quot;user&quot;表里的&quot;host&quot;项，将&quot;localhost&quot;改...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zdb1314">来自：	<span class="blog_title"> Adobe Chow 的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/MK_chan/article/details/82187131","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/MK_chan/article/details/82187131" target="_blank" title="Mysql配置远程登陆">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>配置远程登陆		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-29</span>
				<span class="read-num hover-hide">
					阅读数 
					118</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/MK_chan/article/details/82187131" target="_blank" title="Mysql配置远程登陆">
				<span class="desc oneline">环境：本地windows10，远程Ubuntu16.4+Mysql5.7在win10上远程连接mysql连接不上，首先远端登陆mysql：mysql&amp;amp;gt;showdatabases；mysq...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/MK_chan">来自：	<span class="blog_title"> MK_chan的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/liruxing1715/article/details/8265705","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/liruxing1715/article/details/8265705" target="_blank" title="MySQL 设置允许远程登录">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 设置<em>允许</em><em>远程登录</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-06</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/liruxing1715/article/details/8265705" target="_blank" title="MySQL 设置允许远程登录">
				<span class="desc oneline">1、修改数据表可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入MySQL后，更改“MySQL”数据库里的“user”表里的“Host”项，从“...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/liruxing1715">来自：	<span class="blog_title"> ruxing.li 的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/xinghuo0007/article/details/53842617","strategy":"BlogCommendFromAutoMl2","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xinghuo0007/article/details/53842617" target="_blank" title="MySQL开启root远程访问权限的方法">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>开启<em>root</em>远程访问权限的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-23</span>
				<span class="read-num hover-hide">
					阅读数 
					1632</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xinghuo0007/article/details/53842617" target="_blank" title="MySQL开启root远程访问权限的方法">
				<span class="desc oneline">MySQL开启root远程访问权限允许任何IP使用root账户，口令8个1远程访问方法1Sql代码mysql&gt;GRANTALLPRIVILEGESON.TO‘root’@’%’IDENTIFIEDBY...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xinghuo0007">来自：	<span class="blog_title"> xinghuo0007的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_42884584/article/details/82757524","strategy":"BlogCommendFromAutoMl2","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_42884584/article/details/82757524" target="_blank" title="mysql开启root用户远程访问">
		<h4 class="text-truncate oneline">
				<em>mysql</em>开启<em>root</em>用户远程访问		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-18</span>
				<span class="read-num hover-hide">
					阅读数 
					303</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_42884584/article/details/82757524" target="_blank" title="mysql开启root用户远程访问">
				<span class="desc oneline">①密码改为你的数据库密码grantallprivilegeson.toroot@’%’identifiedby“密码”;②刷新一下privilegesflushprivileges③测试远程登入(第一...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_42884584">来自：	<span class="blog_title"> 爱好jyh的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/iteye_3224/article/details/81845415","strategy":"BlogCommendFromAutoMl2","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/iteye_3224/article/details/81845415" target="_blank" title="如何打开MySQL中root账户的远程登录">
		<h4 class="text-truncate oneline">
				如何打开<em>MySQL</em>中<em>root</em>账户的<em>远程登录</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-30</span>
				<span class="read-num hover-hide">
					阅读数 
					18</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/iteye_3224/article/details/81845415" target="_blank" title="如何打开MySQL中root账户的远程登录">
				<span class="desc oneline">基于安全考虑root账户一般只能本地访问，但是在开发过程中可能需要打开root的远程访问权限。下面是基本的步骤：1、登录到mysql中，为root进行远程访问的授权，执行下面的命令：mysql&amp;amp...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/iteye_3224">来自：	<span class="blog_title"> 网站开发初中级代码参考-转载</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_38981118/article/details/80469529","strategy":"BlogCommendFromAutoMl2","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_38981118/article/details/80469529" target="_blank" title="MySql全套攻略——如何实现远程登录MySql数据库">
		<h4 class="text-truncate oneline">
				<em>MySql</em>全套攻略——如何实现<em>远程登录</em><em>MySql</em>数据库		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-27</span>
				<span class="read-num hover-hide">
					阅读数 
					5342</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_38981118/article/details/80469529" target="_blank" title="MySql全套攻略——如何实现远程登录MySql数据库">
				<span class="desc oneline">导读：有时候，为了开发项目，我们需要在一台服务器上部署MySql数据库服务器，然后使用本地电脑远程访问和管理MySql数据库，那么如何实现MySql的远程登录呢？1.使用命令行远程登录MySql数据库...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_38981118">来自：	<span class="blog_title"> weixin_38981118的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/i_dont_know_a/article/details/80599898","strategy":"BlogCommendFromAutoMl2","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/i_dont_know_a/article/details/80599898" target="_blank" title="MySQL开启远程连接">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>开启远程连接		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-22</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/i_dont_know_a/article/details/80599898" target="_blank" title="MySQL开启远程连接">
				<span class="desc oneline">在同班大神的提点下，终于知道了怎样开启MySQL远程连接。在此小记，另外我使用的是Windows系统，不是Linux。 ▍打开MYSQL1、打开命令提示符：可以通过在搜索“命令提示符”找到它，然后打开...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/i_dont_know_a">来自：	<span class="blog_title"> 蜗牛先生</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/K346K346/article/details/51955546","strategy":"BlogCommendFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/K346K346/article/details/51955546" target="_blank" title="MySQL设置远程访问">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>设置远程访问		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-19</span>
				<span class="read-num hover-hide">
					阅读数 
					1602</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/K346K346/article/details/51955546" target="_blank" title="MySQL设置远程访问">
				<span class="desc oneline">1.授予远程主机访问MySQL在MySQLServer端，执行mysql命令进入mysql命令模式。使用grant命令用来建立新用户，指定用户口令并增加用户权限。命令格式如下：grant[previl...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/K346K346">来自：	<span class="blog_title"> Dablelv的博客专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u012700515/article/details/51727275","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012700515/article/details/51727275" target="_blank" title="mysql远程登录并设置密码">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>远程登录</em>并设置密码		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-21</span>
				<span class="read-num hover-hide">
					阅读数 
					1361</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012700515/article/details/51727275" target="_blank" title="mysql远程登录并设置密码">
				<span class="desc oneline">设置密码为password进行远程登录[root@localhost~]#mysql-uroot-pEnterpassword:WelcometotheMySQLmonitor.Commandsend...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012700515">来自：	<span class="blog_title"> lqbz的总结</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/gebitan505/article/details/51726667","strategy":"BlogCommendFromBaidu","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/gebitan505/article/details/51726667" target="_blank" title="MySQL设置允许用户远程登录">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>设置<em>允许</em>用户<em>远程登录</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-21</span>
				<span class="read-num hover-hide">
					阅读数 
					1568</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/gebitan505/article/details/51726667" target="_blank" title="MySQL设置允许用户远程登录">
				<span class="desc oneline">项目中需要连接虚拟机上面的MySQL数据库，但是总是出错，怀疑本机是否有连接远程数据库的权限。执行命令：mysql&gt;usemysql;mysql&gt;selecthost,userfromuser;查看结...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/gebitan505">来自：	<span class="blog_title"> AndyLizh的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u012730333/article/details/46275491","strategy":"BlogCommendFromBaidu","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012730333/article/details/46275491" target="_blank" title="mysql 允许远程登录配置">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>允许</em><em>远程登录</em>配置		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-30</span>
				<span class="read-num hover-hide">
					阅读数 
					433</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012730333/article/details/46275491" target="_blank" title="mysql 允许远程登录配置">
				<span class="desc oneline">两步：一、 更改“mysql”数据库里的“user”表里的“host”项（经此步便可在远程登录）x:\&gt;mysql-uroot-pvmwaremysql&gt;usemysql;mysql&gt;updateus...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012730333">来自：	<span class="blog_title"> hmg_monkey的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_29246225/article/details/52680394","strategy":"BlogCommendFromBaidu","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_29246225/article/details/52680394" target="_blank" title="开启mysql的远程访问权限">
		<h4 class="text-truncate oneline">
				开启<em>mysql</em>的远程访问权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-27</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_29246225/article/details/52680394" target="_blank" title="开启mysql的远程访问权限">
				<span class="desc oneline">基于安全考虑root账户一般只能本地访问，但是在开发过程中可能需要打开root的远程访问权限。下面是基本的步骤：1、登录到mysql中，为root进行远程访问的授权，执行下面的命令： mysql&gt;GR...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_29246225">来自：	<span class="blog_title"> 小灰的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-556","con":",,"}' data-track-click='{"mod":"kp_popu_62-556","con":",,"}' data-report-view='{"mod":"kp_popu_62-556","keyword":""}' data-report-click='{"mod":"kp_popu_62-556","keyword":""}'><div id="three_ad18" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad18",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/skykingf/article/details/84034484","strategy":"BlogCommendFromAutoMl2","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/skykingf/article/details/84034484" target="_blank" title="MySQL8修改root远程登录密码">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>8修改<em>root</em><em>远程登录</em>密码		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-13</span>
				<span class="read-num hover-hide">
					阅读数 
					711</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/skykingf/article/details/84034484" target="_blank" title="MySQL8修改root远程登录密码">
				<span class="desc oneline">相比MySQL7,8.x版本已经改变了修改远程登录密码的方式。以root为例，正确的方式如下： 1.添加远程登录的账户createuser'root'@'%'identifiedwithmysql_n...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/skykingf">来自：	<span class="blog_title"> skykingf的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/lglglgl/article/details/80227660","strategy":"BlogCommendFromAutoMl2","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lglglgl/article/details/80227660" target="_blank" title="mysql 远程root登陆">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 远程<em>root</em>登陆		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-07</span>
				<span class="read-num hover-hide">
					阅读数 
					186</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lglglgl/article/details/80227660" target="_blank" title="mysql 远程root登陆">
				<span class="desc oneline">登陆mysql-uroot-p切换数据库usemysql更新用户主机updateusersethost='%'whereuser='root'andhost='127.0.0.1';更新密码UPDAT...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lglglgl">来自：	<span class="blog_title"> 空空dream</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/xiongyu1010/article/details/52229988","strategy":"BlogCommendFromAutoMl2","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xiongyu1010/article/details/52229988" target="_blank" title="CentOS下配置MySQL允许root用户远程登录">
		<h4 class="text-truncate oneline">
				CentOS下配置<em>MySQL</em><em>允许</em><em>root</em>用户<em>远程登录</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-17</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xiongyu1010/article/details/52229988" target="_blank" title="CentOS下配置MySQL允许root用户远程登录">
				<span class="desc oneline">在CentOS上成功安装MySQLServer后，发现无法用客户端进行连接，查阅相关质料后发现如果想让root用户支持远程登录，是需要进行额外配置的；配置步骤如下：步骤：修改root密码(可选)#切换...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xiongyu1010">来自：	<span class="blog_title"> 每天进步一点点</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zhengnz/article/details/6308773","strategy":"BlogCommendFromAutoMl2","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhengnz/article/details/6308773" target="_blank" title="MYSQL远程登录权限设置">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em><em>远程登录</em>权限设置		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-08</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhengnz/article/details/6308773" target="_blank" title="MYSQL远程登录权限设置">
				<span class="desc oneline">Mysql默认关闭远程登录权限，如下操作允许用户在任意地点登录：1.进入mysql，GRANTALLPRIVILEGESON*.*TO'root'@'%'IDENTIFIEDBY''WITHGRANT...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhengnz">来自：	<span class="blog_title"> zhengnz的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/friendan/article/details/8711023","strategy":"BlogCommendFromAutoMl2","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/friendan/article/details/8711023" target="_blank" title="MySQL命令行登陆，远程登陆MySQL">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>命令行登陆，远程登陆<em>MySQL</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-23</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/friendan/article/details/8711023" target="_blank" title="MySQL命令行登陆，远程登陆MySQL">
				<span class="desc oneline">关键词：MySQL控制台登陆，MySQL命令行登陆，远程登陆MySQL,MySQL图形管理,navicat10.1.8,navicat下载。注:MySQL图形界面管理工具【navicat10.1.8中...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/friendan">来自：	<span class="blog_title"> friendan的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-1059","con":",,"}' data-track-click='{"mod":"kp_popu_63-1059","con":",,"}' data-report-view='{"mod":"kp_popu_63-1059","keyword":""}' data-report-click='{"mod":"kp_popu_63-1059","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/234?positionId=63&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/xiexievv/article/details/50513996","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xiexievv/article/details/50513996" target="_blank" title="mysql 无法远程登陆解决办法">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 无法远程登陆解决办法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-13</span>
				<span class="read-num hover-hide">
					阅读数 
					4549</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xiexievv/article/details/50513996" target="_blank" title="mysql 无法远程登陆解决办法">
				<span class="desc oneline">linuxMySQL数据库无法远程连接的解决办法关于MySql数据库无法远程连接的问题可以归结为以下几点:1).没有授予相应的权限:2).修改数据user表3).修改防火墙3306端口打开4).修改m...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xiexievv">来自：	<span class="blog_title"> xiexievv的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/Always__/article/details/51873747","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Always__/article/details/51873747" target="_blank" title="解决mysql无法远程登录的问题">
		<h4 class="text-truncate oneline">
				解决<em>mysql</em>无法<em>远程登录</em>的问题		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-10</span>
				<span class="read-num hover-hide">
					阅读数 
					3876</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Always__/article/details/51873747" target="_blank" title="解决mysql无法远程登录的问题">
				<span class="desc oneline">基于安全考虑root账户一般只能本地访问，但是在开发过程中可能需要打开root的远程访问权限。下面我们将列出解决方案。若要允许Linux系统中的mysql数据库可以被远程连接，需要执行以下两个步骤：1...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Always__">来自：	<span class="blog_title"> Always__的代码世界</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/liyf155/article/details/61420245","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<div class="content">
		<a href="https://blog.csdn.net/liyf155/article/details/61420245" target="_blank" title="MySQL5.7 远程登录设置">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>5.7 <em>远程登录</em>设置		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-11</span>
				<span class="read-num hover-hide">
					阅读数 
					2957</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/liyf155/article/details/61420245" target="_blank" title="MySQL5.7 远程登录设置">
				<span class="desc oneline">初次安装MySQL5.7后，是不能远程登录的，需执行以下指令：mysql&gt;grantallprivilegeson*.*to'root'@'%'withgrantoption;ERROR1819(HY...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/liyf155">来自：	<span class="blog_title"> liyf155的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/karen_wang/article/details/7194688","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/karen_wang/article/details/7194688" target="_blank" title="mysql远程登录">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>远程登录</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-11</span>
				<span class="read-num hover-hide">
					阅读数 
					606</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/karen_wang/article/details/7194688" target="_blank" title="mysql远程登录">
				<span class="desc oneline">以下文字来自：http://www.cnblogs.com/frostbelt/archive/2011/02/22/1961186.html  Mysql为了安全性，在默认情况下用户只允许在本地登录...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/karen_wang">来自：	<span class="blog_title"> karen_wang的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/preterhuman_peak/article/details/40396873","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/preterhuman_peak/article/details/40396873" target="_blank" title="MYSQL添加远程用户或允许远程访问三种方法">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em>添加远程用户或<em>允许</em>远程访问三种方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-23</span>
				<span class="read-num hover-hide">
					阅读数 
					14万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/preterhuman_peak/article/details/40396873" target="_blank" title="MYSQL添加远程用户或允许远程访问三种方法">
				<span class="desc oneline">添加远程用户admin密码为passwordGRANTALLPRIVILEGESON*.*TOadmin@localhostIDENTIFIEDBY\'password\'WITHGRANTOPTIO...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/preterhuman_peak">来自：	<span class="blog_title"> 上帝之手</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-1060","con":",,"}' data-track-click='{"mod":"kp_popu_64-1060","con":",,"}' data-report-view='{"mod":"kp_popu_64-1060","keyword":""}' data-report-click='{"mod":"kp_popu_64-1060","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/235?positionId=64&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/xjjxhn1314/article/details/78361404","strategy":"BlogCommendFromAutoMl2","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xjjxhn1314/article/details/78361404" target="_blank" title="Mysql登录数据库,远程登录命令">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>登录数据库,<em>远程登录</em>命令		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-27</span>
				<span class="read-num hover-hide">
					阅读数 
					5702</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xjjxhn1314/article/details/78361404" target="_blank" title="Mysql登录数据库,远程登录命令">
				<span class="desc oneline">通过Mysql命令连接数据库1、连接本地数据库    mysql-u用户名 -p密码   --默认连接主机为localhost，默认端口为33062、远程连接数据库，需指定连接的主机IP地址    m...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xjjxhn1314">来自：	<span class="blog_title"> xjjxhn1314的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_33851604/article/details/91627272","strategy":"BlogCommendFromAutoMl2","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_33851604/article/details/91627272" target="_blank" title="远程无法连接mysql">
		<h4 class="text-truncate oneline">
				远程无法连接<em>mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-09</span>
				<span class="read-num hover-hide">
					阅读数 
					14</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_33851604/article/details/91627272" target="_blank" title="远程无法连接mysql">
				<span class="desc oneline">为什么80%的码农都做不了架构师？&amp;gt;&amp;gt;&amp;gt;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_33851604">来自：	<span class="blog_title"> weixin_33851604的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_30609287/article/details/97984907","strategy":"BlogCommendFromAutoMl2","index":"31"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_30609287/article/details/97984907" target="_blank" title="mariadb自带命令行客户端指令笔记">
		<h4 class="text-truncate oneline">
				mariadb自带命令行客户端指令笔记		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-22</span>
				<span class="read-num hover-hide">
					阅读数 
					5</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_30609287/article/details/97984907" target="_blank" title="mariadb自带命令行客户端指令笔记">
				<span class="desc oneline">mysql-H主机IP-u用户名-p-p表示要输密码,不要直接输了,要回车后在程序里输入显示数据库列表:showdatabases;选择XX数据库:useXX;显示数据库里的表:showtables;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_30609287">来自：	<span class="blog_title"> weixin_30609287的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/feixiang2039/article/details/81164136","strategy":"BlogCommendFromAutoMl2","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/feixiang2039/article/details/81164136" target="_blank" title="Mac  mysql 无法远程连接">
		<h4 class="text-truncate oneline">
				Mac  <em>mysql</em> 无法远程连接		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-23</span>
				<span class="read-num hover-hide">
					阅读数 
					2821</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/feixiang2039/article/details/81164136" target="_blank" title="Mac  mysql 无法远程连接">
				<span class="desc oneline">现象：在Mac系统上，mysql不允许远程连接。首先按照常规的方法操作：进入mysql：$mysql-uroot-pmysql&amp;amp;gt;GRANTALLPRIVILEGESON*.*TO'roo...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/feixiang2039">来自：	<span class="blog_title"> 学海无涯乐相伴</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/charly2018/article/details/7335633","strategy":"BlogCommendFromAutoMl2","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/charly2018/article/details/7335633" target="_blank" title="如何远程连接MySQL">
		<h4 class="text-truncate oneline">
				如何远程连接<em>MySQL</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-09</span>
				<span class="read-num hover-hide">
					阅读数 
					1017</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/charly2018/article/details/7335633" target="_blank" title="如何远程连接MySQL">
				<span class="desc oneline">新使用MySQL，说起来是个简单的事情，但是却费了些周折：1、登陆服务器端，进入命令行，windowscmd;2、设置用户、密码让指定的IP访问：mysql-uroot-p或安装的快捷方式进入:MyS...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/charly2018">来自：	<span class="blog_title"> charly2018的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-1061","con":",,"}' data-track-click='{"mod":"kp_popu_65-1061","con":",,"}' data-report-view='{"mod":"kp_popu_65-1061","keyword":""}' data-report-click='{"mod":"kp_popu_65-1061","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/236?positionId=65&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/pinkdaddy/article/details/83378622","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/pinkdaddy/article/details/83378622" target="_blank" title="MySQL5.7 root开放远程连接">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>5.7 <em>root</em>开放远程连接		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-25</span>
				<span class="read-num hover-hide">
					阅读数 
					2547</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/pinkdaddy/article/details/83378622" target="_blank" title="MySQL5.7 root开放远程连接">
				<span class="desc oneline">例如，你想使用账号username使用密码password从任何主机连接到mysql服务器的话。GRANTALLPRIVILEGESON*.*TO'username'@'%'IDENTIFIEDBY'...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/pinkdaddy">来自：	<span class="blog_title"> pinkdaddy的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_42412601/article/details/86527921","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_42412601/article/details/86527921" target="_blank" title="mysql root用户远程访问权限">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>root</em>用户远程访问权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-17</span>
				<span class="read-num hover-hide">
					阅读数 
					159</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_42412601/article/details/86527921" target="_blank" title="mysql root用户远程访问权限">
				<span class="desc oneline">1.GRANTALLPRIVILEGESON.TO‘root’@’%’IDENTIFIEDBY‘123456’2.flushprivileges;ok!</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_42412601">来自：	<span class="blog_title"> weixin_42412601的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
	<div class="recommend-item-box  recommend-download-box clearfix"  data-report-click='{"mod":"popu_614","dest":"https://download.csdn.net/download/u011496822/10749644","strategy":"BlogCommendFromBaidu","index":"36"}'>
		<a href="https://download.csdn.net/download/u011496822/10749644" target="_blank">
			<div class="content clearfix">
				<div class="">
					<h4 class="text-truncate oneline clearfix">
						<em>mysql</em>给<em>root</em>开启远程访问权限，修改<em>root</em>密码					</h4>
					<span class="data float-right">10-28</span>
				</div>
				<div class="desc oneline">
						mysql给root开启远程访问权限，修改root密码				</div>
				<span class="type-show type-show-download">下载</span>
			</div>
		</a>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392468888","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<a href="https://bbs.csdn.net/topics/392468888" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em>给<em>root</em>开启远程访问权限，修改<em>root</em>密码下载		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">10-29</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">mysql给root开启远程访问权限，修改root密码mysql给root开启远程访问权限，修改root密码 相关下载链接：//download.csdn.net/download/u01149682</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_26710805/article/details/79776897","strategy":"BlogCommendFromAutoMl2","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_26710805/article/details/79776897" target="_blank" title="Mysql授权远程登陆">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>授权远程登陆		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-01</span>
				<span class="read-num hover-hide">
					阅读数 
					9051</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_26710805/article/details/79776897" target="_blank" title="Mysql授权远程登陆">
				<span class="desc oneline">在Windows环境上操作。步骤如下：1.打开cmd窗口，登陆mysqlmysql-uroot-p1234562.使用mysql数据库usemysql3.查看结果中host一行中是否有%,如果有%，此...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_26710805">来自：	<span class="blog_title"> Shelter</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/jianjiao7869/article/details/81029171","strategy":"BlogCommendFromAutoMl2","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jianjiao7869/article/details/81029171" target="_blank" title="修改mysql远程数据库链接密码">
		<h4 class="text-truncate oneline">
				修改<em>mysql</em>远程数据库链接密码		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-13</span>
				<span class="read-num hover-hide">
					阅读数 
					2719</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jianjiao7869/article/details/81029171" target="_blank" title="修改mysql远程数据库链接密码">
				<span class="desc oneline">1、Navicat链接服务器2、主机名就是服务器的IP地址，因为默认用户名和密码都是root，很容易被别人登录。我们这里修改一下链接服务器的用户和密码。3、还有这种操作？服务器登录mysqlmysql...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jianjiao7869">来自：	<span class="blog_title"> Test Oracle</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qcyfred/article/details/76470924","strategy":"BlogCommendFromAutoMl2","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qcyfred/article/details/76470924" target="_blank" title="MySQL：控制台远程登录命令">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>：控制台<em>远程登录</em>命令		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-05</span>
				<span class="read-num hover-hide">
					阅读数 
					8127</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qcyfred/article/details/76470924" target="_blank" title="MySQL：控制台远程登录命令">
				<span class="desc oneline">如题。</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qcyfred">来自：	<span class="blog_title"> qcyfred的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/davidyezhiwei/article/details/50736560","strategy":"BlogCommendFromAutoMl2","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/davidyezhiwei/article/details/50736560" target="_blank" title="MySQL允许root帐号远程登录">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>允许</em><em>root</em>帐号<em>远程登录</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-25</span>
				<span class="read-num hover-hide">
					阅读数 
					1351</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/davidyezhiwei/article/details/50736560" target="_blank" title="MySQL允许root帐号远程登录">
				<span class="desc oneline">我们可以看到有四个root账户，两个空账号，你也会发现只有采用localhost的root设置了密码，其余都无需密码。那么我们要修改mysql的root密码我们可以使用这个命令/usr/local/b...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/davidyezhiwei">来自：	<span class="blog_title"> davidyezhiwei的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zyddj123/article/details/80482329","strategy":"BlogCommendFromAutoMl2","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zyddj123/article/details/80482329" target="_blank" title="mysql远程登录（授权与撤销授权）">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>远程登录</em>（授权与撤销授权）		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-28</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zyddj123/article/details/80482329" target="_blank" title="mysql远程登录（授权与撤销授权）">
				<span class="desc oneline">一、远程登录授权：GRANT1.登录musqlmysql-uroot-r2.输入密码登陆之后授权：mysql&amp;amp;amp;gt;GRANTALLPRIVILEGESON*.*TO'root'@'%...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zyddj123">来自：	<span class="blog_title"> 清晨一场梦</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/waixingrenabc/article/details/81739377","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/waixingrenabc/article/details/81739377" target="_blank" title="MySql开放远程访问权限">
		<h4 class="text-truncate oneline">
				<em>MySql</em>开放远程访问权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-16</span>
				<span class="read-num hover-hide">
					阅读数 
					637</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/waixingrenabc/article/details/81739377" target="_blank" title="MySql开放远程访问权限">
				<span class="desc oneline">在部署mysql的服务器中登录mysqlmysql -u root -p  2.执行sql语句A：--使用mysql系统数据库  	use mysql;   	--配置192.168.1.10可以通过...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/waixingrenabc">来自：	<span class="blog_title"> 外星人（waixingrenabc）</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-653","con":",,"}' data-track-click='{"mod":"kp_popu_67-653","con":",,"}' data-report-view='{"mod":"kp_popu_67-653","keyword":""}' data-report-click='{"mod":"kp_popu_67-653","keyword":""}'><div id="three_ad43" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : '9gAEHz',
                placeholderId: "three_ad43",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 12,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/a9529lty/article/details/14519471","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/a9529lty/article/details/14519471" target="_blank" title="开通mysql root 用户远程访问权限">
		<h4 class="text-truncate oneline">
				开通<em>mysql</em> <em>root</em> 用户远程访问权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-08</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/a9529lty/article/details/14519471" target="_blank" title="开通mysql root 用户远程访问权限">
				<span class="desc oneline">基于安全考虑root账户一般只能本地访问，但是在开发过程中可能需要打开root的远程访问权限。下面是基本的步骤：1、登录到mysql中，为root进行远程访问的授权，执行下面的命令： mysql&gt;GR...</span>
			</a>
			<span class="blog_title_box oneline no-title">
									<span class="type-show type-show-blog type-show-after">博文</span>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/junqing124/article/details/53180874","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/junqing124/article/details/53180874" target="_blank" title="mysql5.7 允许root远程访问">
		<h4 class="text-truncate oneline">
				<em>mysql</em>5.7 <em>允许</em><em>root</em>远程访问		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-16</span>
				<span class="read-num hover-hide">
					阅读数 
					9194</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/junqing124/article/details/53180874" target="_blank" title="mysql5.7 允许root远程访问">
				<span class="desc oneline">updatemysql.usersetHost='%'whereHOST='localhost'andUser='root';flushprivileges;</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/junqing124">来自：	<span class="blog_title"> junqing124的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/green_hunter/article/details/8926331","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/green_hunter/article/details/8926331" target="_blank" title="Mysql初始化root密码和允许远程访问">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>初始化<em>root</em>密码和<em>允许</em>远程访问		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-14</span>
				<span class="read-num hover-hide">
					阅读数 
					220</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/green_hunter/article/details/8926331" target="_blank" title="Mysql初始化root密码和允许远程访问">
				<span class="desc oneline">mysql默认root用户没有密码，输入mysql–uroot进入mysql1、初始化root密码进入mysql数据库?1mysql&gt;update user set password=PASSWORD...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/green_hunter">来自：	<span class="blog_title"> green_hunter的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/deanwq/article/details/70575195","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/deanwq/article/details/70575195" target="_blank" title="给MySQL添加root用户的远程权限">
		<h4 class="text-truncate oneline">
				给<em>MySQL</em>添加<em>root</em>用户的远程权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-24</span>
				<span class="read-num hover-hide">
					阅读数 
					5143</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/deanwq/article/details/70575195" target="_blank" title="给MySQL添加root用户的远程权限">
				<span class="desc oneline">#mysql-uroot-p123456&gt;usemysql;&gt;selecthost,user,passwordfromuser;&gt;createuser'root'@'%'identifiedby'12...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/deanwq">来自：	<span class="blog_title"> roy的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/RobinsonWang_C/article/details/78201426","strategy":"BlogCommendFromAutoMl2","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/RobinsonWang_C/article/details/78201426" target="_blank" title="mysql开启远程访问权限">
		<h4 class="text-truncate oneline">
				<em>mysql</em>开启远程访问权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-11</span>
				<span class="read-num hover-hide">
					阅读数 
					4147</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/RobinsonWang_C/article/details/78201426" target="_blank" title="mysql开启远程访问权限">
				<span class="desc oneline">1.修改mysql配置进入mysql命令行模式，输入如下命令：grantallprivilegeson*.*to'root'@'%'identifiedby'password'withgrantopt...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/RobinsonWang_C">来自：	<span class="blog_title"> 彩虹柠檬水</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zhangbest2009/article/details/7767667","strategy":"BlogCommendFromAutoMl2","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhangbest2009/article/details/7767667" target="_blank" title="mysql 开启远程连接权限">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 开启远程连接权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-20</span>
				<span class="read-num hover-hide">
					阅读数 
					776</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhangbest2009/article/details/7767667" target="_blank" title="mysql 开启远程连接权限">
				<span class="desc oneline">原文链接：http://vanadiumlin.iteye.com/blog/866763 首先确认你开启了防火墙并且为3306端口开启例外~！如何开启MySQL的远程帐号2008-07-09┆8,4...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhangbest2009">来自：	<span class="blog_title"> 叮咚侠的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtjaYgxsNTktZWR1.html" target="_blank">
                        mysql 培训</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtjaYg0sOTAtZWR1.html" target="_blank">
                        mysql的培训</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/zhazhagu">
              <img src="https://avatar.csdn.net/B/1/C/3_zhazhagu.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/4.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/zhazhagu"  class="" id="uid">小gu</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="62">
                        <dt><a href="https://blog.csdn.net/zhazhagu?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/zhazhagu?t=1"><span class="count">62</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="13">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">13</span></dd>
        </dl>
        <dl class="text-center" title="37">
            <dt>喜欢</dt>
            <dd><span class="count">37</span></dd>
        </dl>
        <dl class="text-center" title="12">
            <dt>评论</dt>
            <dd><span class="count">12</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="4级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-4"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="116088">
                11万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="1494">
                1494            </dd>
        </dl>
        <dl title="49284">
            <dt>排名：</dt>
            <dd>4万+</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="1024勋章">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/1024huodong.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/1024huodong.svg" alt="">
                                   <p>1024勋章</p>
                               </div>
                               <div class="right-box">
                                   #1024程序员节#活动勋章，当日发布原创博客即可获得                               </div>
                           </div>
                       </div>
                   </div>
                                                             <div class="icon-badge" title="勤写标兵Lv1">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/qinxiebiaobing_l1_t2.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/qinxiebiaobing_l1_t2.svg" alt="">
                                   <p>勤写标兵Lv1</p>
                               </div>
                               <div class="right-box">
                                   授予每个自然周发布1篇到3篇原创IT博文的用户。本勋章将于次周周三上午根据用户上周的博文发布情况由系统自动颁发。                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/zhazhagu">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-76","con":",,"}' data-track-click='{"mod":"kp_popu_56-76","con":",,"}' data-report-view='{"mod":"kp_popu_56-76","keyword":""}' data-report-click='{"mod":"kp_popu_56-76","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3032528",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/zhazhagu/article/details/95310092" target="_blank" >
                                        dos文件备份以及mysql数据库备份                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/zhazhagu/article/details/95306562" target="_blank" >
                                        sqlServer数据copy                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/zhazhagu/article/details/93053903" target="_blank" >
                                        Redis基本操作-List列表                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/zhazhagu/article/details/93048210" target="_blank" >
                                        Redis基本使用-字符串数据类型操作                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/zhazhagu/article/details/90439849" target="_blank" >
                                        Redis基本介绍及安装                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box flexible-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7471267">
                    <span class="title oneline">mysql</span>
                    <span class="count float-right">17篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7108650">
                    <span class="title oneline">Linux</span>
                    <span class="count float-right">7篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7345426">
                    <span class="title oneline">浏览器兼容性</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7345440">
                    <span class="title oneline">前端</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7369023">
                    <span class="title oneline">markdown</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7369154">
                    <span class="title oneline">book</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7472170">
                    <span class="title oneline">端口无法访问</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7472339">
                    <span class="title oneline">AppScan</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7472548">
                    <span class="title oneline">安全测试</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7483980">
                    <span class="title oneline">存储引擎</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7485570">
                    <span class="title oneline">网络</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7543999">
                    <span class="title oneline">oracle</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7544000">
                    <span class="title oneline">静默安装</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7544001">
                    <span class="title oneline">centos7</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7553445">
                    <span class="title oneline">ulimit</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7553446">
                    <span class="title oneline">web系统僵死</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7556651">
                    <span class="title oneline">Python入门</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7579174">
                    <span class="title oneline">Loadrunner</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7579175">
                    <span class="title oneline">测试</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7580749">
                    <span class="title oneline">top</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7641664">
                    <span class="title oneline">性能</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7641738">
                    <span class="title oneline">WireShark</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7641739">
                    <span class="title oneline">入门教程</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7668004">
                    <span class="title oneline">工具</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7704552">
                    <span class="title oneline">数据库</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7756618">
                    <span class="title oneline">软件</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7769732">
                    <span class="title oneline">图书分类系统</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7780892">
                    <span class="title oneline">反射</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7782345">
                    <span class="title oneline">虚拟机</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7782346">
                    <span class="title oneline">VMware</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7782347">
                    <span class="title oneline">VirtualBox</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7816834">
                    <span class="title oneline">读书</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7816835">
                    <span class="title oneline">高性能MySQL</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7827596">
                    <span class="title oneline">Eclipse</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7827597">
                    <span class="title oneline">条件断点</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/7948361">
                    <span class="title oneline">docker</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/8106878">
                    <span class="title oneline">http_load</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/8417929">
                    <span class="title oneline">备份还原</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/8546156">
                    <span class="title oneline">cisco实验</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/8566229">
                    <span class="title oneline">cron</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/8566230">
                    <span class="title oneline">权限</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/8970275">
                    <span class="title oneline">Redis</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/zhazhagu/article/category/8970276">
                    <span class="title oneline">NoSQL</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2019/07">
                    2019年7月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2019/06">
                    2019年6月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2019/05">
                    2019年5月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2019/03">
                    2019年3月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2019/02">
                    2019年2月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2019/01">
                    2019年1月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2018/12">
                    2018年12月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2018/11">
                    2018年11月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2018/10">
                    2018年10月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2018/08">
                    2018年8月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2018/07">
                    2018年7月                    <span class="count float-right">9篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2018/06">
                    2018年6月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2018/05">
                    2018年5月                    <span class="count float-right">11篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2018/04">
                    2018年4月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2018/03">
                    2018年3月                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2018/02">
                    2018年2月                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2017/12">
                    2017年12月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2017/11">
                    2017年11月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2017/10">
                    2017年10月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/zhazhagu/article/month/2017/08">
                    2017年8月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/zhazhagu/article/details/80335178" >
                                                工具-IDM(Google浏览器下载插件)                    </a>
					<p class="read">阅读数 <span>35285</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/zhazhagu/article/details/81064406" >
                                                MySQL允许root远程登录                    </a>
					<p class="read">阅读数 <span>13440</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/zhazhagu/article/details/80205202" >
                                                查看MySQL运行状态                    </a>
					<p class="read">阅读数 <span>11423</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/zhazhagu/article/details/79457354" >
                                                MySQL查看建库建表语句                    </a>
					<p class="read">阅读数 <span>9766</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/zhazhagu/article/details/79695486" >
                                                MySQL数据库查看表所有外键                    </a>
					<p class="read">阅读数 <span>7421</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/zhazhagu/article/details/80335178#comments">工具-IDM(Google浏览器下...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/zhazhagu" class="user-name" target="_blank">zhazhagu：</a>[reply]weixin_44473351[/reply]
您指的是插件下载不了还是插件不下载内容？                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/zhazhagu/article/details/80335178#comments">工具-IDM(Google浏览器下...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/weixin_44473351" class="user-name" target="_blank">weixin_44473351：</a>无法下载                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/zhazhagu/article/details/81807488#comments">基于Docker的Oracle12...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/zhazhagu" class="user-name" target="_blank">zhazhagu：</a>[reply]s1078229131[/reply]
刚才进行了看了下昨天拉取结果，拉取成功了，总大小14.9GB                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/zhazhagu/article/details/81807488#comments">基于Docker的Oracle12...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/zhazhagu" class="user-name" target="_blank">zhazhagu：</a>[reply]s1078229131[/reply]
您好：您可以先测试一下拉取hello world的镜像，我本地刚才测试了一下是可以拉取镜像的，熟读颇为缓慢（还未拉取完成）                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/zhazhagu/article/details/81807488#comments">基于Docker的Oracle12...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/s1078229131" class="user-name" target="_blank">s1078229131：</a>作者您好，请问mritschel/oracle12cr2_base 该镜像是不是不能使用了，我按照您的步骤来安装 最终提示我
pull access denied for mritschel/oracle12cr2_base, repository does not exist or may require 'docker login'                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-77","con":",,"}' data-track-click='{"mod":"kp_popu_57-77","con":",,"}' data-report-view='{"mod":"kp_popu_57-77","keyword":""}' data-report-click='{"mod":"kp_popu_57-77","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3163270",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box long-width">
			<button class=" long-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">1</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/zhazhagu/article/details/80937926" title="VMware虚拟机导入VirtualBox">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/zhazhagu/article/details/81113618" title="读书-高性能MySQL 第一章">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/zhazhagu/article/details/80937926" title="VMware虚拟机导入VirtualBox">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/zhazhagu/article/details/81113618" title="读书-高性能MySQL 第一章">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "81064406";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/zhazhagu/article/details/81064406";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "MySQL允许root远程登录 - 小谷的博客";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = 'atom-one-dark';
	var highlight = ["mysql","\u5141\u8bb8","root","\u8fdc\u7a0b\u767b\u5f55"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

<!-- 高亮未与 markdown兼容  -->
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/chart.css" />
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/lib/chart.min.js"></script>
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/widget2chart.js"></script>
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-dark.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin-yellow/skin-yellow-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
